package com.oa.co.mapper;
/*
 *                                                     __----~~~~~~~~~~~------___
 *                                    .  .   ~~//====......          __--~ ~~
 *                    -.            \_|//     |||\\  ~~~~~~::::... /~
 *                 ___-==_       _-~o~  \/    |||  \\            _/~~-
 *         __---~~~.==~||\=_    -_--~/_-~|-   |\\   \\        _/~
 *     _-~~     .=~    |  \\-_    '-~7  /-   /  ||    \      /
 *   .~       .~       |   \\ -_    /  /-   /   ||      \   /
 *  /  ____  /         |     \\ ~-_/  /|- _/   .||       \ /
 *  |~~    ~~|--~~~~--_ \     ~==-/   | \~--===~~        .\
 *           '         ~-|      /|    |-~\~~       __--~~
 *                       |-~~-_/ |    |   ~\_   _-~            /\
 *                            /  \     \__   \/~                \__
 *                        _--~ _/ | .-~~____--~-/                  ~~==.
 *                       ((->/~   '.|||' -_|    ~~-/ ,              . _||
 *                                  -_     ~\      ~~---l__i__i__i--~~_/
 *                                  _-~-__   ~)  \--______________--~~
 *                                //.-~~~-~_--~- |-------~~~~~~~~
 *                                       //.-~~~--\
 *                       ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 *
 *                               神兽保佑            永无BUG
 */

import com.oa.co.bo.Business_tripBo;
import com.oa.co.pojo.Business_trip;
import com.oa.co.vo.ScheduleBarVo;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author sunXuDong
 * @data 2023/5/8
 */
public interface BusinessTripMapper {

    @Select("select * from business_trip where t_id=#{t_id}")
    List<Business_trip> queryAll(@Param("t_id") Integer province);

    List<Business_trip> queryProname(String proname);

    List<Business_trip> queryApplicant(@Param("t_id")Integer province);

    List<Business_trip> btcList(Business_trip business_trip);
    @Delete("delete from business_trip where id = #{id}")
    Integer deleteById(Integer id);

    Integer update(Business_trip business_trip);

    Integer add(Business_trip business_trip);

    List<ScheduleBarVo> bar();

    List<ScheduleBarVo> pPie();

    List<ScheduleBarVo> aPie();

    List<Business_tripBo> btcListBo(Business_trip business_trip);
}
